Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
GiftRegistryID (FK)(PK) | A unique system assigned identifier for this particular CustomerGiftRegistry. | ID_RGST_CT_GF | Identity | integer | GiftRegistryLineItem(AS_ITM_GF_RGST) |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | GiftRegistryLineItem(AS_ITM_GF_RGST) |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
Quantity | The number of items purchased for the GiftRegistration on this line item. | QU_LTM_GF_RGST | Quantity | DECIMAL(9,3) | |